You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
Solved Can I insert Blank Lines when using: Fill, Series, Columns, Date?
I need to replicate a Form 52 times for each year.
It needs to have two blank lines between each Date Line.
Is there any way to do it.
It is currently very tedious and error pron.
Your help is appreciated.
I have attached two examples: one the Form and the other the Excel Screen.
The Excel Sheet was converted to a PDF so it could be uploaded.
A Spreadsheet format was not one of the Upload Formats available.
Best regards,
Mike Lynch
- Computer type
- PC/Desktop
- Computer Manufacturer/Model Number
- Two HP Desktops. One in the Laundry Room / Bed Room.
- OS
- Microsoft Windows 7 Professional 64-bit 7601 Multiprocessor Free Service Pack 1
- CPU
- Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz
- Motherboard
- Hewlett-Packard 3396
- Memory
- 8.00 GB
- Graphics Card(s)
- Intel(R) HD Graphics 4000
- Sound Card
- (1) Realtek High Definition Audio (2) Intel(R) Display Aud
- Monitor(s) Displays
- Hanns-G
- Screen Resolution
- 1440 x 900 x 32 bits (4294967296 colors) @ 59 Hz
- Hard Drives
- (1) ATA WDC WD40EZRX-00S SCSI Disk Device (2) HP Officejet Pro 86 USB Device (3) WD My Book 1230 USB Device
- PSU
- Whatever came with the CMT.
- Case
- HP CMT Black.
- Cooling
- Whatever came with the CMT.
- Keyboard
- Logitech K740.
- Mouse
- Microsoft Optical Mouse 1000.
- Internet Speed
- Spectrum 25Mbs.
- Antivirus
- WebRoot, Microsoft Security Essentials.
- Browser
- EDGE
- Other Info
- HP Officejet Pro 8600 Plus.
WD MyBook 4TB.
Senior Member
Guru
Gold Member
VIP
- Computer type
- PC/Desktop
- Computer Manufacturer/Model Number
- Self built using existing case
- OS
- Windows 7 Home Premium 64 bit sp1
- CPU
- Intel i5 3570 3.4Ghz Ivy Bridge SKT 1155 quad core
- Motherboard
- Gigabyte Z77-HD3 SKT 1155 2xSata 3, 4x USB 3.0
- Memory
- G-Skill Rip Jaws 16Gb (8x2) DDR3 -1600 PC3 12800 CL 10 red
- Graphics Card(s)
- Gigabyte NVIDIA GT610 1Gb DDR3 810/1200 PCI-E 2.0 Silent
- Sound Card
- NVIDIA High Definition & Realtech High Definition Audio
- Monitor(s) Displays
- 2 x Philips 226V4L 16:9 aspect ratio
- Screen Resolution
- 1920 x 1080 HD
- Hard Drives
- Samsung 840 Pro 256gb SSD, SATA 3.
Hitachi Touro Portable 1tb, USB 3.0 HDD used for image b/ups.
- PSU
- Corsair VS450
- Case
- Codeng
- Cooling
- PSU fan & CPU fan
- Keyboard
- Logitech
- Mouse
- Logitech Wireless trackball M570
- Internet Speed
- Wireless 3G. 3mg down & 550kb up.
- Antivirus
- Bitdefender Internet Security 2020
- Browser
- Opera (Current Version) & Firefox
- Other Info
- MS Office 2013 Pro. Davis weather station software. MGE Nova 600 avr UPS.
New member
Pro User
VIP
Thread Starter
Thank you Ranger4!
It worked and it has saved me hours and frustration.
Best regards,
Mike Lynch
- Computer type
- PC/Desktop
- Computer Manufacturer/Model Number
- Two HP Desktops. One in the Laundry Room / Bed Room.
- OS
- Microsoft Windows 7 Professional 64-bit 7601 Multiprocessor Free Service Pack 1
- CPU
- Intel(R) Core(TM) i7-3770 CPU @ 3.40GHz
- Motherboard
- Hewlett-Packard 3396
- Memory
- 8.00 GB
- Graphics Card(s)
- Intel(R) HD Graphics 4000
- Sound Card
- (1) Realtek High Definition Audio (2) Intel(R) Display Aud
- Monitor(s) Displays
- Hanns-G
- Screen Resolution
- 1440 x 900 x 32 bits (4294967296 colors) @ 59 Hz
- Hard Drives
- (1) ATA WDC WD40EZRX-00S SCSI Disk Device (2) HP Officejet Pro 86 USB Device (3) WD My Book 1230 USB Device
- PSU
- Whatever came with the CMT.
- Case
- HP CMT Black.
- Cooling
- Whatever came with the CMT.
- Keyboard
- Logitech K740.
- Mouse
- Microsoft Optical Mouse 1000.
- Internet Speed
- Spectrum 25Mbs.
- Antivirus
- WebRoot, Microsoft Security Essentials.
- Browser
- EDGE
- Other Info
- HP Officejet Pro 8600 Plus.
WD MyBook 4TB.
Senior Member
Guru
Gold Member
VIP
Thanks for getting back & glad I could help.
- Computer type
- PC/Desktop
- Computer Manufacturer/Model Number
- Self built using existing case
- OS
- Windows 7 Home Premium 64 bit sp1
- CPU
- Intel i5 3570 3.4Ghz Ivy Bridge SKT 1155 quad core
- Motherboard
- Gigabyte Z77-HD3 SKT 1155 2xSata 3, 4x USB 3.0
- Memory
- G-Skill Rip Jaws 16Gb (8x2) DDR3 -1600 PC3 12800 CL 10 red
- Graphics Card(s)
- Gigabyte NVIDIA GT610 1Gb DDR3 810/1200 PCI-E 2.0 Silent
- Sound Card
- NVIDIA High Definition & Realtech High Definition Audio
- Monitor(s) Displays
- 2 x Philips 226V4L 16:9 aspect ratio
- Screen Resolution
- 1920 x 1080 HD
- Hard Drives
- Samsung 840 Pro 256gb SSD, SATA 3.
Hitachi Touro Portable 1tb, USB 3.0 HDD used for image b/ups.
- PSU
- Corsair VS450
- Case
- Codeng
- Cooling
- PSU fan & CPU fan
- Keyboard
- Logitech
- Mouse
- Logitech Wireless trackball M570
- Internet Speed
- Wireless 3G. 3mg down & 550kb up.
- Antivirus
- Bitdefender Internet Security 2020
- Browser
- Opera (Current Version) & Firefox
- Other Info
- MS Office 2013 Pro. Davis weather station software. MGE Nova 600 avr UPS.
