Copying but figures do not pasting in correct row & columns

D

DIPASGL

New Member
Joined
Oct 26, 2022
Messages
39
Office Version
  1. 2003 or older
Platform
  1. Windows
Hi

I am copying so many lines from accounting software and pasting on excel for stock matching purpose
When I copy control c and paste on excel file
Data looks like below SEE - if see row 1 is good but row 2 my some dat is good unto description but rest data went 125 purchases so on at row 3 similarly some got at row 4 and some at row 5 . II want my data in one single row wise not half in row 2 and half in row 3.
I hope you understand my problem, please help . I already tried Ctl shift v and paste special too but that did not help - thanks


Posting DateDocument TypeDocument No.G/L Account No.DescriptionBranch CodeGen. Posting TypeGen. Bus. Posting GroupGen. Prod. Posting GroupQuantityAmountBal. Account TypeBal. Account No.User IDReversedFA Entry TypeFA Entry No.Entry No.
9/1/2023BGJ-0199135250Strawberries125PurchaseGENNO GST0162G/L AccountALEXNo5884232
9/1/2023InvoiceBPINV-1257765250Wa Growers Fresh
125PurchaseVENDORGEN011.78G/L AccountALEXNo5884375
9/1/2023InvoiceBPINV-1257765250Coles
125PurchaseVENDORGEN041.45G/L AccountALEXNo5884377
9/1/2023InvoiceBPINV-1257765250Harrisdale oriental
125PurchaseVENDORGEN07.64G/L AccountALEXNo5884379
9/1/2023InvoiceBPINV-1257765250Tim Fresh
125PurchaseVENDORGEN08.95G/L AccountALEXNo5884381
9/1/2023InvoiceBPINV-1257765250Woolworths
125PurchaseVENDORGEN016.37G/L AccountALEXNo5884383
9/3/2023BGJ-0199185250Strawberries Puchased125PurchaseGENNO GST0162G/L AccountALEXNo5884587
9/5/2023BGJ-0199265250Strawberries125PurchaseGENNO GST0162G/L AccountALEXNo5887433
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
My guess is that the data you are copying is in the format you are pasting into Excel. I do not think Excel would be the cause for the formatting differences. Consider exporting your data from the other software and then opening that in Excel to see if the formatting is better.

Hope that helps,

Doug
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
Create report by matching part of item and populate for each cell under item across sheets
Replies
2
Views
205
Ali M
A
O
  • Solved
Populate headers based on column and merge amount for multiple words
Replies
7
Views
197
Omar M
O
H
  • Solved
Copy rows if cells in column "K" end with either "X" or "x".
Replies
3
Views
228
rollis13
rollis13
O
  • Solved
Put amount in DEBIT,CREDIT columns based on matching part of item
Replies
9
Views
166
Omran Y
O
O
  • Solved
VBA - Filter columns, cut/paste rows new sheet, pivot table
2
Replies
12
Views
275
Skyybot
Skyybot

Forum statistics

Threads
1,223,714
Messages
6,174,049
Members
452,542
Latest member
Bricklin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top